CREATE TABLE [dbo].[MatchingGiftPlanFundType]
(
[MatchingGiftPlanFundTypeKey] [uniqueidentifier] NOT NULL,
[MatchingGiftPlanKey] [uniqueidentifier] NOT NULL,
[FundTypeKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[MatchingGiftPlanFundType] ADD CONSTRAINT [PK_MatchingGiftPlanFundType] PRIMARY KEY CLUSTERED ([MatchingGiftPlanFundTypeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MatchingGiftPlanFundType_FundTypeKey] ON [dbo].[MatchingGiftPlanFundType] ([FundTypeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_MatchingGiftPlanFundType_MatchingGiftPlanKey] ON [dbo].[MatchingGiftPlanFundType] ([MatchingGiftPlanKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MatchingGiftPlanFundType] ADD CONSTRAINT [FK_MatchingGiftPlanFundType_FundTypeRef] FOREIGN KEY ([FundTypeKey]) REFERENCES [dbo].[FundTypeRef] ([FundTypeKey])
GO
ALTER TABLE [dbo].[MatchingGiftPlanFundType] ADD CONSTRAINT [FK_MatchingGiftPlanFundType_MatchingGiftPlan] FOREIGN KEY ([MatchingGiftPlanKey]) REFERENCES [dbo].[MatchingGiftPlan] ([MatchingGiftPlanKey])
GO